In SAS^® IT Resource Management 3.4, the following error occurs when you submit a user-written adapter staging job:

678        %LET ADMIN=Adm9084; 
679            LIBNAME Adm9084 ("/sasdata/admin") ACCESS=READONLY; 
NOTE: Libref ADM9084 was successfully assigned as follows: 
      Levels:           1 
      Engine(1):        V9 
      Physical Name(1): /sasdata/admin 
ERROR: The %LOCAL statement is not valid in open code. 
680        %local oldfmt; 
681        %let oldfmt=%sysfunc(getoption(FMTSEARCH)); 
682        options insert=(fmtsearch = &ADMIN..FORMATS); 
683        options nofmterr; 

The error is a result of an erroneous, auto–generated %LOCAL statement in SAS IT Resource Management.

To circumvent this error, modify the SAS IT Resource Management User-Written Staging transformation, as follows:

1. From the IT Data Marts tree in SAS IT Resource Management, double-click the job that is to contain the User-Written Staging transformation. By default, the job opens on the Diagram tab of the Job Editor window.
2. Click the Code tab in the Job Editor window. This tab enables you to manager the code for the transformation before you execute a job.
3. Change the selection for Code generation mode to User written body.
4. Locate the following SAS statement in the generated code and delete it:
%local oldfmt;
5. Save the SAS IT Resource Management staging job.

Operating System and Release Information